package com.ecoolex.chinadutyfree.retailer.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class DirectMailGoodsOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public DirectMailGoodsOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DirectMailGoodsOrderExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public DirectMailGoodsOrderExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        DirectMailGoodsOrderExample example = new DirectMailGoodsOrderExample();
        return example.createCriteria();
    }

    public DirectMailGoodsOrderExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public DirectMailGoodsOrderExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public DirectMailGoodsOrderExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsOrderExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsOrderExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("directmailgoodsorder.OrderId is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("directmailgoodsorder.OrderId is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.OrderId =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.OrderId <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorder.OrderId >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.OrderId >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Integer value) {
            addCriterion("directmailgoodsorder.OrderId <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.OrderId <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorder.OrderId in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorder.OrderId not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorder.OrderId between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorder.OrderId not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("directmailgoodsorder.UserId is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("directmailgoodsorder.UserId is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.UserId =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UserId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.UserId <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UserId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorder.UserId >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UserId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.UserId >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UserId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("directmailgoodsorder.UserId <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UserId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.UserId <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UserId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorder.UserId in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorder.UserId not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorder.UserId between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorder.UserId not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("directmailgoodsorder.OrderNo is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("directmailgoodsorder.OrderNo is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("directmailgoodsorder.OrderNo =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("directmailgoodsorder.OrderNo <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("directmailgoodsorder.OrderNo >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.OrderNo >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("directmailgoodsorder.OrderNo <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.OrderNo <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.OrderNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("directmailgoodsorder.OrderNo like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("directmailgoodsorder.OrderNo not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("directmailgoodsorder.OrderNo in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("directmailgoodsorder.OrderNo not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.OrderNo between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.OrderNo not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIsNull() {
            addCriterion("directmailgoodsorder.CurrencyType is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIsNotNull() {
            addCriterion("directmailgoodsorder.CurrencyType is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeEqualTo(String value) {
            addCriterion("directmailgoodsorder.CurrencyType =", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CurrencyType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotEqualTo(String value) {
            addCriterion("directmailgoodsorder.CurrencyType <>", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CurrencyType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThan(String value) {
            addCriterion("directmailgoodsorder.CurrencyType >", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CurrencyType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.CurrencyType >=", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CurrencyType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThan(String value) {
            addCriterion("directmailgoodsorder.CurrencyType <", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CurrencyType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.CurrencyType <=", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CurrencyType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLike(String value) {
            addCriterion("directmailgoodsorder.CurrencyType like", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotLike(String value) {
            addCriterion("directmailgoodsorder.CurrencyType not like", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIn(List<String> values) {
            addCriterion("directmailgoodsorder.CurrencyType in", values, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotIn(List<String> values) {
            addCriterion("directmailgoodsorder.CurrencyType not in", values, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.CurrencyType between", value1, value2, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.CurrencyType not between", value1, value2, "currencyType");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceIsNull() {
            addCriterion("directmailgoodsorder.GoodsTotalPrice is null");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceIsNotNull() {
            addCriterion("directmailgoodsorder.GoodsTotalPrice is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.GoodsTotalPrice =", value, "goodsTotalPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.GoodsTotalPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.GoodsTotalPrice <>", value, "goodsTotalPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.GoodsTotalPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorder.GoodsTotalPrice >", value, "goodsTotalPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.GoodsTotalPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.GoodsTotalPrice >=", value, "goodsTotalPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.GoodsTotalPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorder.GoodsTotalPrice <", value, "goodsTotalPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.GoodsTotalPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.GoodsTotalPrice <=", value, "goodsTotalPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.GoodsTotalPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorder.GoodsTotalPrice in", values, "goodsTotalPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorder.GoodsTotalPrice not in", values, "goodsTotalPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorder.GoodsTotalPrice between", value1, value2, "goodsTotalPrice");
            return (Criteria) this;
        }

        public Criteria andGoodsTotalPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorder.GoodsTotalPrice not between", value1, value2, "goodsTotalPrice");
            return (Criteria) this;
        }

        public Criteria andFreightIsNull() {
            addCriterion("directmailgoodsorder.Freight is null");
            return (Criteria) this;
        }

        public Criteria andFreightIsNotNull() {
            addCriterion("directmailgoodsorder.Freight is not null");
            return (Criteria) this;
        }

        public Criteria andFreightEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.Freight =", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Freight = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.Freight <>", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Freight <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorder.Freight >", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Freight > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.Freight >=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Freight >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorder.Freight <", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Freight < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.Freight <=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Freight <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorder.Freight in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorder.Freight not in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorder.Freight between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorder.Freight not between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksIsNull() {
            addCriterion("directmailgoodsorder.FreightRemarks is null");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksIsNotNull() {
            addCriterion("directmailgoodsorder.FreightRemarks is not null");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksEqualTo(String value) {
            addCriterion("directmailgoodsorder.FreightRemarks =", value, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.FreightRemarks = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightRemarksNotEqualTo(String value) {
            addCriterion("directmailgoodsorder.FreightRemarks <>", value, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.FreightRemarks <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightRemarksGreaterThan(String value) {
            addCriterion("directmailgoodsorder.FreightRemarks >", value, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.FreightRemarks > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.FreightRemarks >=", value, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.FreightRemarks >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightRemarksLessThan(String value) {
            addCriterion("directmailgoodsorder.FreightRemarks <", value, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.FreightRemarks < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightRemarksLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.FreightRemarks <=", value, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.FreightRemarks <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFreightRemarksLike(String value) {
            addCriterion("directmailgoodsorder.FreightRemarks like", value, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksNotLike(String value) {
            addCriterion("directmailgoodsorder.FreightRemarks not like", value, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksIn(List<String> values) {
            addCriterion("directmailgoodsorder.FreightRemarks in", values, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksNotIn(List<String> values) {
            addCriterion("directmailgoodsorder.FreightRemarks not in", values, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.FreightRemarks between", value1, value2, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andFreightRemarksNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.FreightRemarks not between", value1, value2, "freightRemarks");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNull() {
            addCriterion("directmailgoodsorder.TotalPrice is null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNotNull() {
            addCriterion("directmailgoodsorder.TotalPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.TotalPrice =", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TotalPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.TotalPrice <>", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TotalPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorder.TotalPrice >", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TotalPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.TotalPrice >=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TotalPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorder.TotalPrice <", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TotalPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.TotalPrice <=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TotalPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTotalPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorder.TotalPrice in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorder.TotalPrice not in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorder.TotalPrice between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorder.TotalPrice not between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceIsNull() {
            addCriterion("directmailgoodsorder.TaxPrice is null");
            return (Criteria) this;
        }

        public Criteria andTaxPriceIsNotNull() {
            addCriterion("directmailgoodsorder.TaxPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTaxPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.TaxPrice =", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TaxPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.TaxPrice <>", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TaxPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorder.TaxPrice >", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TaxPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.TaxPrice >=", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TaxPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorder.TaxPrice <", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TaxPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.TaxPrice <=", value, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.TaxPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andTaxPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorder.TaxPrice in", values, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorder.TaxPrice not in", values, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorder.TaxPrice between", value1, value2, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andTaxPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorder.TaxPrice not between", value1, value2, "taxPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceIsNull() {
            addCriterion("directmailgoodsorder.RealPrice is null");
            return (Criteria) this;
        }

        public Criteria andRealPriceIsNotNull() {
            addCriterion("directmailgoodsorder.RealPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRealPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.RealPrice =", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.RealPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.RealPrice <>", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.RealPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsorder.RealPrice >", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.RealPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.RealPrice >=", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.RealPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsorder.RealPrice <", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.RealPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsorder.RealPrice <=", value, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.RealPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRealPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorder.RealPrice in", values, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsorder.RealPrice not in", values, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorder.RealPrice between", value1, value2, "realPrice");
            return (Criteria) this;
        }

        public Criteria andRealPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsorder.RealPrice not between", value1, value2, "realPrice");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIsNull() {
            addCriterion("directmailgoodsorder.PaymentNo is null");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIsNotNull() {
            addCriterion("directmailgoodsorder.PaymentNo is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentNoEqualTo(String value) {
            addCriterion("directmailgoodsorder.PaymentNo =", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotEqualTo(String value) {
            addCriterion("directmailgoodsorder.PaymentNo <>", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThan(String value) {
            addCriterion("directmailgoodsorder.PaymentNo >", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.PaymentNo >=", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThan(String value) {
            addCriterion("directmailgoodsorder.PaymentNo <", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.PaymentNo <=", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentNoLike(String value) {
            addCriterion("directmailgoodsorder.PaymentNo like", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotLike(String value) {
            addCriterion("directmailgoodsorder.PaymentNo not like", value, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoIn(List<String> values) {
            addCriterion("directmailgoodsorder.PaymentNo in", values, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotIn(List<String> values) {
            addCriterion("directmailgoodsorder.PaymentNo not in", values, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.PaymentNo between", value1, value2, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentNoNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.PaymentNo not between", value1, value2, "paymentNo");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNull() {
            addCriterion("directmailgoodsorder.PaymentTime is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIsNotNull() {
            addCriterion("directmailgoodsorder.PaymentTime is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorder.PaymentTime =", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorder.PaymentTime <>", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorder.PaymentTime >", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorder.PaymentTime >=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThan(Date value) {
            addCriterion("directmailgoodsorder.PaymentTime <", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorder.PaymentTime <=", value, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.PaymentTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaymentTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorder.PaymentTime in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorder.PaymentTime not in", values, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorder.PaymentTime between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorder.PaymentTime not between", value1, value2, "paymentTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdIsNull() {
            addCriterion("directmailgoodsorder.DeliveryMannerId is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdIsNotNull() {
            addCriterion("directmailgoodsorder.DeliveryMannerId is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.DeliveryMannerId =", value, "deliveryMannerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryMannerId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.DeliveryMannerId <>", value, "deliveryMannerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryMannerId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsorder.DeliveryMannerId >", value, "deliveryMannerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryMannerId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.DeliveryMannerId >=", value, "deliveryMannerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryMannerId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdLessThan(Integer value) {
            addCriterion("directmailgoodsorder.DeliveryMannerId <", value, "deliveryMannerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryMannerId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsorder.DeliveryMannerId <=", value, "deliveryMannerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryMannerId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdIn(List<Integer> values) {
            addCriterion("directmailgoodsorder.DeliveryMannerId in", values, "deliveryMannerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsorder.DeliveryMannerId not in", values, "deliveryMannerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorder.DeliveryMannerId between", value1, value2, "deliveryMannerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryMannerIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsorder.DeliveryMannerId not between", value1, value2, "deliveryMannerId");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoIsNull() {
            addCriterion("directmailgoodsorder.DeliveryNo is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoIsNotNull() {
            addCriterion("directmailgoodsorder.DeliveryNo is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoEqualTo(String value) {
            addCriterion("directmailgoodsorder.DeliveryNo =", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryNo = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotEqualTo(String value) {
            addCriterion("directmailgoodsorder.DeliveryNo <>", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryNo <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryNoGreaterThan(String value) {
            addCriterion("directmailgoodsorder.DeliveryNo >", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryNo > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryNoGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.DeliveryNo >=", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryNo >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLessThan(String value) {
            addCriterion("directmailgoodsorder.DeliveryNo <", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryNo < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.DeliveryNo <=", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryNo <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLike(String value) {
            addCriterion("directmailgoodsorder.DeliveryNo like", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotLike(String value) {
            addCriterion("directmailgoodsorder.DeliveryNo not like", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoIn(List<String> values) {
            addCriterion("directmailgoodsorder.DeliveryNo in", values, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotIn(List<String> values) {
            addCriterion("directmailgoodsorder.DeliveryNo not in", values, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.DeliveryNo between", value1, value2, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.DeliveryNo not between", value1, value2, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIsNull() {
            addCriterion("directmailgoodsorder.DeliveryTime is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIsNotNull() {
            addCriterion("directmailgoodsorder.DeliveryTime is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorder.DeliveryTime =", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorder.DeliveryTime <>", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorder.DeliveryTime >", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorder.DeliveryTime >=", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThan(Date value) {
            addCriterion("directmailgoodsorder.DeliveryTime <", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorder.DeliveryTime <=", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.DeliveryTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorder.DeliveryTime in", values, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorder.DeliveryTime not in", values, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorder.DeliveryTime between", value1, value2, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorder.DeliveryTime not between", value1, value2, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeIsNull() {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime is null");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeIsNotNull() {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime =", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.ConfirmReceiptTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime <>", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.ConfirmReceiptTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime >", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.ConfirmReceiptTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime >=", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.ConfirmReceiptTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeLessThan(Date value) {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime <", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.ConfirmReceiptTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime <=", value, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.ConfirmReceiptTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime in", values, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime not in", values, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime between", value1, value2, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andConfirmReceiptTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorder.ConfirmReceiptTime not between", value1, value2, "confirmReceiptTime");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("directmailgoodsorder.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("directmailgoodsorder.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("directmailgoodsorder.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("directmailgoodsorder.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("directmailgoodsorder.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("directmailgoodsorder.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("directmailgoodsorder.`Status` like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("directmailgoodsorder.`Status` not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("directmailgoodsorder.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("directmailgoodsorder.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("directmailgoodsorder.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("directmailgoodsorder.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("directmailgoodsorder.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("directmailgoodsorder.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("directmailgoodsorder.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsorder.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("directmailgoodsorder.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsorder.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("directmailgoodsorder.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("directmailgoodsorder.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsorder.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsorder.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("directmailgoodsorder.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("directmailgoodsorder.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("directmailgoodsorder.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsorder.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("directmailgoodsorder.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("directmailgoodsorder.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("directmailgoodsorder.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("directmailgoodsorder.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("directmailgoodsorder.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsorder.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("directmailgoodsorder.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("directmailgoodsorder.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorder.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorder.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorder.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorder.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("directmailgoodsorder.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorder.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorder.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorder.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorder.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorder.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("directmailgoodsorder.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("directmailgoodsorder.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("directmailgoodsorder.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsorder.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("directmailgoodsorder.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("directmailgoodsorder.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsorder.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("directmailgoodsorder.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("directmailgoodsorder.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("directmailgoodsorder.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsorder.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsorder.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("directmailgoodsorder.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("directmailgoodsorder.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsorder.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsorder.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsorder.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorder.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("directmailgoodsorder.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsorder.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(DirectMailGoodsOrder.Column column) {
            addCriterion(new StringBuilder("directmailgoodsorder.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsorder.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsorder.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorder.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsorder.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private DirectMailGoodsOrderExample example;

        protected Criteria(DirectMailGoodsOrderExample example) {
            super();
            this.example = example;
        }

        public DirectMailGoodsOrderExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(DirectMailGoodsOrder.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(DirectMailGoodsOrder.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.chinadutyfree.retailer.entity.DirectMailGoodsOrderExample example);
    }
}